Nonetheless Another component I am struggling to try and do following the mass copy and paste has operate I want Yet another code that will update column A accordingly these that the Job num from sheet two will fill in to every in between duties two and ten,000 I have Successfully Submitted (Awaiting Approval)